CREATE PROCEDURE TempDeleteSystemConfigVar
        @ParameterName nvarchar(255)
AS
BEGIN
    DECLARE
        @PropertyDefinitionKey uniqueidentifier

    SELECT @PropertyDefinitionKey = PropertyDefinitionKey
      FROM SystemConfigParameterRef
     WHERE ParameterName = @ParameterName

    DELETE FROM SystemConfig WHERE ParameterName = @ParameterName

    DELETE FROM SystemConfigPageParameterRef WHERE ParameterName = @ParameterName

    DELETE FROM SystemConfigParameterRef WHERE ParameterName = @ParameterName

    DELETE FROM PropertyDefinition WHERE PropertyDefinitionKey = @PropertyDefinitionKey
END

GO